package com.citcc4.traffic.data.domain.order;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class WorkorderEntityExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer pageNo = 1;

    protected Integer startRow;

    protected Integer pageSize = 10;

    protected String fields;

    public WorkorderEntityExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPageNo(Integer pageNo) {
        this.pageNo=pageNo;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageNo() {
        return pageNo;
    }

    public void setStartRow(Integer startRow) {
        this.startRow=startRow;
    }

    public Integer getStartRow() {
        return startRow;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize=pageSize;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setFields(String fields) {
        this.fields=fields;
    }

    public String getFields() {
        return fields;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andWorkorderIdIsNull() {
            addCriterion("WORKORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdIsNotNull() {
            addCriterion("WORKORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdEqualTo(String value) {
            addCriterion("WORKORDER_ID =", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdNotEqualTo(String value) {
            addCriterion("WORKORDER_ID <>", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdGreaterThan(String value) {
            addCriterion("WORKORDER_ID >", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdGreaterThanOrEqualTo(String value) {
            addCriterion("WORKORDER_ID >=", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdLessThan(String value) {
            addCriterion("WORKORDER_ID <", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdLessThanOrEqualTo(String value) {
            addCriterion("WORKORDER_ID <=", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdLike(String value) {
            addCriterion("WORKORDER_ID like", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdNotLike(String value) {
            addCriterion("WORKORDER_ID not like", value, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdIn(List<String> values) {
            addCriterion("WORKORDER_ID in", values, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdNotIn(List<String> values) {
            addCriterion("WORKORDER_ID not in", values, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdBetween(String value1, String value2) {
            addCriterion("WORKORDER_ID between", value1, value2, "workorderId");
            return (Criteria) this;
        }

        public Criteria andWorkorderIdNotBetween(String value1, String value2) {
            addCriterion("WORKORDER_ID not between", value1, value2, "workorderId");
            return (Criteria) this;
        }

        public Criteria andVideoIdIsNull() {
            addCriterion("VIDEO_ID is null");
            return (Criteria) this;
        }

        public Criteria andVideoIdIsNotNull() {
            addCriterion("VIDEO_ID is not null");
            return (Criteria) this;
        }

        public Criteria andVideoIdEqualTo(String value) {
            addCriterion("VIDEO_ID =", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdNotEqualTo(String value) {
            addCriterion("VIDEO_ID <>", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdGreaterThan(String value) {
            addCriterion("VIDEO_ID >", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdGreaterThanOrEqualTo(String value) {
            addCriterion("VIDEO_ID >=", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdLessThan(String value) {
            addCriterion("VIDEO_ID <", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdLessThanOrEqualTo(String value) {
            addCriterion("VIDEO_ID <=", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdLike(String value) {
            addCriterion("VIDEO_ID like", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdNotLike(String value) {
            addCriterion("VIDEO_ID not like", value, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdIn(List<String> values) {
            addCriterion("VIDEO_ID in", values, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdNotIn(List<String> values) {
            addCriterion("VIDEO_ID not in", values, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdBetween(String value1, String value2) {
            addCriterion("VIDEO_ID between", value1, value2, "videoId");
            return (Criteria) this;
        }

        public Criteria andVideoIdNotBetween(String value1, String value2) {
            addCriterion("VIDEO_ID not between", value1, value2, "videoId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("USER_ID =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("USER_ID <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("USER_ID >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("USER_ID >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("USER_ID <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("USER_ID <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("USER_ID like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("USER_ID not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("USER_ID in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("USER_ID not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("USER_ID between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("USER_ID not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdIsNull() {
            addCriterion("MIRROR_ID is null");
            return (Criteria) this;
        }

        public Criteria andMirrorIdIsNotNull() {
            addCriterion("MIRROR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMirrorIdEqualTo(String value) {
            addCriterion("MIRROR_ID =", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdNotEqualTo(String value) {
            addCriterion("MIRROR_ID <>", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdGreaterThan(String value) {
            addCriterion("MIRROR_ID >", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdGreaterThanOrEqualTo(String value) {
            addCriterion("MIRROR_ID >=", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdLessThan(String value) {
            addCriterion("MIRROR_ID <", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdLessThanOrEqualTo(String value) {
            addCriterion("MIRROR_ID <=", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdLike(String value) {
            addCriterion("MIRROR_ID like", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdNotLike(String value) {
            addCriterion("MIRROR_ID not like", value, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdIn(List<String> values) {
            addCriterion("MIRROR_ID in", values, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdNotIn(List<String> values) {
            addCriterion("MIRROR_ID not in", values, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdBetween(String value1, String value2) {
            addCriterion("MIRROR_ID between", value1, value2, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andMirrorIdNotBetween(String value1, String value2) {
            addCriterion("MIRROR_ID not between", value1, value2, "mirrorId");
            return (Criteria) this;
        }

        public Criteria andVideoUrlIsNull() {
            addCriterion("VIDEO_URL is null");
            return (Criteria) this;
        }

        public Criteria andVideoUrlIsNotNull() {
            addCriterion("VIDEO_URL is not null");
            return (Criteria) this;
        }

        public Criteria andVideoUrlEqualTo(String value) {
            addCriterion("VIDEO_URL =", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlNotEqualTo(String value) {
            addCriterion("VIDEO_URL <>", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlGreaterThan(String value) {
            addCriterion("VIDEO_URL >", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlGreaterThanOrEqualTo(String value) {
            addCriterion("VIDEO_URL >=", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlLessThan(String value) {
            addCriterion("VIDEO_URL <", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlLessThanOrEqualTo(String value) {
            addCriterion("VIDEO_URL <=", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlLike(String value) {
            addCriterion("VIDEO_URL like", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlNotLike(String value) {
            addCriterion("VIDEO_URL not like", value, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlIn(List<String> values) {
            addCriterion("VIDEO_URL in", values, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlNotIn(List<String> values) {
            addCriterion("VIDEO_URL not in", values, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlBetween(String value1, String value2) {
            addCriterion("VIDEO_URL between", value1, value2, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andVideoUrlNotBetween(String value1, String value2) {
            addCriterion("VIDEO_URL not between", value1, value2, "videoUrl");
            return (Criteria) this;
        }

        public Criteria andSnapTimeIsNull() {
            addCriterion("SNAP_TIME is null");
            return (Criteria) this;
        }

        public Criteria andSnapTimeIsNotNull() {
            addCriterion("SNAP_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andSnapTimeEqualTo(BigDecimal value) {
            addCriterion("SNAP_TIME =", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeNotEqualTo(BigDecimal value) {
            addCriterion("SNAP_TIME <>", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeGreaterThan(BigDecimal value) {
            addCriterion("SNAP_TIME >", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SNAP_TIME >=", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeLessThan(BigDecimal value) {
            addCriterion("SNAP_TIME <", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SNAP_TIME <=", value, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeIn(List<BigDecimal> values) {
            addCriterion("SNAP_TIME in", values, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeNotIn(List<BigDecimal> values) {
            addCriterion("SNAP_TIME not in", values, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SNAP_TIME between", value1, value2, "snapTime");
            return (Criteria) this;
        }

        public Criteria andSnapTimeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SNAP_TIME not between", value1, value2, "snapTime");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("DESCRIPTION is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("DESCRIPTION is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("DESCRIPTION =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("DESCRIPTION <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("DESCRIPTION >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("DESCRIPTION <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("DESCRIPTION like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("DESCRIPTION not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("DESCRIPTION in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("DESCRIPTION not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("DESCRIPTION between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("DESCRIPTION not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("ORDER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("ORDER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(Long value) {
            addCriterion("ORDER_TYPE =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(Long value) {
            addCriterion("ORDER_TYPE <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(Long value) {
            addCriterion("ORDER_TYPE >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(Long value) {
            addCriterion("ORDER_TYPE >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(Long value) {
            addCriterion("ORDER_TYPE <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(Long value) {
            addCriterion("ORDER_TYPE <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<Long> values) {
            addCriterion("ORDER_TYPE in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<Long> values) {
            addCriterion("ORDER_TYPE not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(Long value1, Long value2) {
            addCriterion("ORDER_TYPE between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(Long value1, Long value2) {
            addCriterion("ORDER_TYPE not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeIsNull() {
            addCriterion("POLICE_TRANSGRESS_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeIsNotNull() {
            addCriterion("POLICE_TRANSGRESS_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeEqualTo(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE =", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeNotEqualTo(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE <>", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeGreaterThan(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE >", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeGreaterThanOrEqualTo(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE >=", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeLessThan(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE <", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeLessThanOrEqualTo(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE <=", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeLike(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE like", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeNotLike(String value) {
            addCriterion("POLICE_TRANSGRESS_CODE not like", value, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeIn(List<String> values) {
            addCriterion("POLICE_TRANSGRESS_CODE in", values, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeNotIn(List<String> values) {
            addCriterion("POLICE_TRANSGRESS_CODE not in", values, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeBetween(String value1, String value2) {
            addCriterion("POLICE_TRANSGRESS_CODE between", value1, value2, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andPoliceTransgressCodeNotBetween(String value1, String value2) {
            addCriterion("POLICE_TRANSGRESS_CODE not between", value1, value2, "policeTransgressCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeIsNull() {
            addCriterion("ROAD_CODE is null");
            return (Criteria) this;
        }

        public Criteria andRoadCodeIsNotNull() {
            addCriterion("ROAD_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andRoadCodeEqualTo(String value) {
            addCriterion("ROAD_CODE =", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeNotEqualTo(String value) {
            addCriterion("ROAD_CODE <>", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeGreaterThan(String value) {
            addCriterion("ROAD_CODE >", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ROAD_CODE >=", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeLessThan(String value) {
            addCriterion("ROAD_CODE <", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeLessThanOrEqualTo(String value) {
            addCriterion("ROAD_CODE <=", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeLike(String value) {
            addCriterion("ROAD_CODE like", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeNotLike(String value) {
            addCriterion("ROAD_CODE not like", value, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeIn(List<String> values) {
            addCriterion("ROAD_CODE in", values, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeNotIn(List<String> values) {
            addCriterion("ROAD_CODE not in", values, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeBetween(String value1, String value2) {
            addCriterion("ROAD_CODE between", value1, value2, "roadCode");
            return (Criteria) this;
        }

        public Criteria andRoadCodeNotBetween(String value1, String value2) {
            addCriterion("ROAD_CODE not between", value1, value2, "roadCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeIsNull() {
            addCriterion("SECTIONS_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeIsNotNull() {
            addCriterion("SECTIONS_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeEqualTo(String value) {
            addCriterion("SECTIONS_CODE =", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeNotEqualTo(String value) {
            addCriterion("SECTIONS_CODE <>", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeGreaterThan(String value) {
            addCriterion("SECTIONS_CODE >", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SECTIONS_CODE >=", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeLessThan(String value) {
            addCriterion("SECTIONS_CODE <", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeLessThanOrEqualTo(String value) {
            addCriterion("SECTIONS_CODE <=", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeLike(String value) {
            addCriterion("SECTIONS_CODE like", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeNotLike(String value) {
            addCriterion("SECTIONS_CODE not like", value, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeIn(List<String> values) {
            addCriterion("SECTIONS_CODE in", values, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeNotIn(List<String> values) {
            addCriterion("SECTIONS_CODE not in", values, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeBetween(String value1, String value2) {
            addCriterion("SECTIONS_CODE between", value1, value2, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andSectionsCodeNotBetween(String value1, String value2) {
            addCriterion("SECTIONS_CODE not between", value1, value2, "sectionsCode");
            return (Criteria) this;
        }

        public Criteria andCoverurlIsNull() {
            addCriterion("COVERURL is null");
            return (Criteria) this;
        }

        public Criteria andCoverurlIsNotNull() {
            addCriterion("COVERURL is not null");
            return (Criteria) this;
        }

        public Criteria andCoverurlEqualTo(String value) {
            addCriterion("COVERURL =", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlNotEqualTo(String value) {
            addCriterion("COVERURL <>", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlGreaterThan(String value) {
            addCriterion("COVERURL >", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlGreaterThanOrEqualTo(String value) {
            addCriterion("COVERURL >=", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlLessThan(String value) {
            addCriterion("COVERURL <", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlLessThanOrEqualTo(String value) {
            addCriterion("COVERURL <=", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlLike(String value) {
            addCriterion("COVERURL like", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlNotLike(String value) {
            addCriterion("COVERURL not like", value, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlIn(List<String> values) {
            addCriterion("COVERURL in", values, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlNotIn(List<String> values) {
            addCriterion("COVERURL not in", values, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlBetween(String value1, String value2) {
            addCriterion("COVERURL between", value1, value2, "coverurl");
            return (Criteria) this;
        }

        public Criteria andCoverurlNotBetween(String value1, String value2) {
            addCriterion("COVERURL not between", value1, value2, "coverurl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlIsNull() {
            addCriterion("SYNTHETIC_IMG_URL is null");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlIsNotNull() {
            addCriterion("SYNTHETIC_IMG_URL is not null");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlEqualTo(String value) {
            addCriterion("SYNTHETIC_IMG_URL =", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlNotEqualTo(String value) {
            addCriterion("SYNTHETIC_IMG_URL <>", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlGreaterThan(String value) {
            addCriterion("SYNTHETIC_IMG_URL >", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("SYNTHETIC_IMG_URL >=", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlLessThan(String value) {
            addCriterion("SYNTHETIC_IMG_URL <", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlLessThanOrEqualTo(String value) {
            addCriterion("SYNTHETIC_IMG_URL <=", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlLike(String value) {
            addCriterion("SYNTHETIC_IMG_URL like", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlNotLike(String value) {
            addCriterion("SYNTHETIC_IMG_URL not like", value, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlIn(List<String> values) {
            addCriterion("SYNTHETIC_IMG_URL in", values, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlNotIn(List<String> values) {
            addCriterion("SYNTHETIC_IMG_URL not in", values, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlBetween(String value1, String value2) {
            addCriterion("SYNTHETIC_IMG_URL between", value1, value2, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andSyntheticImgUrlNotBetween(String value1, String value2) {
            addCriterion("SYNTHETIC_IMG_URL not between", value1, value2, "syntheticImgUrl");
            return (Criteria) this;
        }

        public Criteria andMinitypeIsNull() {
            addCriterion("MINITYPE is null");
            return (Criteria) this;
        }

        public Criteria andMinitypeIsNotNull() {
            addCriterion("MINITYPE is not null");
            return (Criteria) this;
        }

        public Criteria andMinitypeEqualTo(String value) {
            addCriterion("MINITYPE =", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeNotEqualTo(String value) {
            addCriterion("MINITYPE <>", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeGreaterThan(String value) {
            addCriterion("MINITYPE >", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeGreaterThanOrEqualTo(String value) {
            addCriterion("MINITYPE >=", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeLessThan(String value) {
            addCriterion("MINITYPE <", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeLessThanOrEqualTo(String value) {
            addCriterion("MINITYPE <=", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeLike(String value) {
            addCriterion("MINITYPE like", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeNotLike(String value) {
            addCriterion("MINITYPE not like", value, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeIn(List<String> values) {
            addCriterion("MINITYPE in", values, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeNotIn(List<String> values) {
            addCriterion("MINITYPE not in", values, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeBetween(String value1, String value2) {
            addCriterion("MINITYPE between", value1, value2, "minitype");
            return (Criteria) this;
        }

        public Criteria andMinitypeNotBetween(String value1, String value2) {
            addCriterion("MINITYPE not between", value1, value2, "minitype");
            return (Criteria) this;
        }

        public Criteria andUploadtimeIsNull() {
            addCriterion("UPLOADTIME is null");
            return (Criteria) this;
        }

        public Criteria andUploadtimeIsNotNull() {
            addCriterion("UPLOADTIME is not null");
            return (Criteria) this;
        }

        public Criteria andUploadtimeEqualTo(Date value) {
            addCriterionForJDBCDate("UPLOADTIME =", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("UPLOADTIME <>", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeGreaterThan(Date value) {
            addCriterionForJDBCDate("UPLOADTIME >", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPLOADTIME >=", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeLessThan(Date value) {
            addCriterionForJDBCDate("UPLOADTIME <", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPLOADTIME <=", value, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeIn(List<Date> values) {
            addCriterionForJDBCDate("UPLOADTIME in", values, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("UPLOADTIME not in", values, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPLOADTIME between", value1, value2, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andUploadtimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPLOADTIME not between", value1, value2, "uploadtime");
            return (Criteria) this;
        }

        public Criteria andVideoStateIsNull() {
            addCriterion("VIDEO_STATE is null");
            return (Criteria) this;
        }

        public Criteria andVideoStateIsNotNull() {
            addCriterion("VIDEO_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andVideoStateEqualTo(Long value) {
            addCriterion("VIDEO_STATE =", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateNotEqualTo(Long value) {
            addCriterion("VIDEO_STATE <>", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateGreaterThan(Long value) {
            addCriterion("VIDEO_STATE >", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateGreaterThanOrEqualTo(Long value) {
            addCriterion("VIDEO_STATE >=", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateLessThan(Long value) {
            addCriterion("VIDEO_STATE <", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateLessThanOrEqualTo(Long value) {
            addCriterion("VIDEO_STATE <=", value, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateIn(List<Long> values) {
            addCriterion("VIDEO_STATE in", values, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateNotIn(List<Long> values) {
            addCriterion("VIDEO_STATE not in", values, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateBetween(Long value1, Long value2) {
            addCriterion("VIDEO_STATE between", value1, value2, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoStateNotBetween(Long value1, Long value2) {
            addCriterion("VIDEO_STATE not between", value1, value2, "videoState");
            return (Criteria) this;
        }

        public Criteria andVideoSizeIsNull() {
            addCriterion("VIDEO_SIZE is null");
            return (Criteria) this;
        }

        public Criteria andVideoSizeIsNotNull() {
            addCriterion("VIDEO_SIZE is not null");
            return (Criteria) this;
        }

        public Criteria andVideoSizeEqualTo(BigDecimal value) {
            addCriterion("VIDEO_SIZE =", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeNotEqualTo(BigDecimal value) {
            addCriterion("VIDEO_SIZE <>", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeGreaterThan(BigDecimal value) {
            addCriterion("VIDEO_SIZE >", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VIDEO_SIZE >=", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeLessThan(BigDecimal value) {
            addCriterion("VIDEO_SIZE <", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VIDEO_SIZE <=", value, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeIn(List<BigDecimal> values) {
            addCriterion("VIDEO_SIZE in", values, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeNotIn(List<BigDecimal> values) {
            addCriterion("VIDEO_SIZE not in", values, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIDEO_SIZE between", value1, value2, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoSizeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VIDEO_SIZE not between", value1, value2, "videoSize");
            return (Criteria) this;
        }

        public Criteria andVideoMd5IsNull() {
            addCriterion("VIDEO_MD5 is null");
            return (Criteria) this;
        }

        public Criteria andVideoMd5IsNotNull() {
            addCriterion("VIDEO_MD5 is not null");
            return (Criteria) this;
        }

        public Criteria andVideoMd5EqualTo(String value) {
            addCriterion("VIDEO_MD5 =", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5NotEqualTo(String value) {
            addCriterion("VIDEO_MD5 <>", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5GreaterThan(String value) {
            addCriterion("VIDEO_MD5 >", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5GreaterThanOrEqualTo(String value) {
            addCriterion("VIDEO_MD5 >=", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5LessThan(String value) {
            addCriterion("VIDEO_MD5 <", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5LessThanOrEqualTo(String value) {
            addCriterion("VIDEO_MD5 <=", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5Like(String value) {
            addCriterion("VIDEO_MD5 like", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5NotLike(String value) {
            addCriterion("VIDEO_MD5 not like", value, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5In(List<String> values) {
            addCriterion("VIDEO_MD5 in", values, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5NotIn(List<String> values) {
            addCriterion("VIDEO_MD5 not in", values, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5Between(String value1, String value2) {
            addCriterion("VIDEO_MD5 between", value1, value2, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andVideoMd5NotBetween(String value1, String value2) {
            addCriterion("VIDEO_MD5 not between", value1, value2, "videoMd5");
            return (Criteria) this;
        }

        public Criteria andPushTimeIsNull() {
            addCriterion("PUSH_TIME is null");
            return (Criteria) this;
        }

        public Criteria andPushTimeIsNotNull() {
            addCriterion("PUSH_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andPushTimeEqualTo(Date value) {
            addCriterionForJDBCDate("PUSH_TIME =", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("PUSH_TIME <>", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("PUSH_TIME >", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("PUSH_TIME >=", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeLessThan(Date value) {
            addCriterionForJDBCDate("PUSH_TIME <", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("PUSH_TIME <=", value, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeIn(List<Date> values) {
            addCriterionForJDBCDate("PUSH_TIME in", values, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("PUSH_TIME not in", values, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("PUSH_TIME between", value1, value2, "pushTime");
            return (Criteria) this;
        }

        public Criteria andPushTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("PUSH_TIME not between", value1, value2, "pushTime");
            return (Criteria) this;
        }

        public Criteria andSnapTypeIsNull() {
            addCriterion("SNAP_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSnapTypeIsNotNull() {
            addCriterion("SNAP_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSnapTypeEqualTo(Long value) {
            addCriterion("SNAP_TYPE =", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeNotEqualTo(Long value) {
            addCriterion("SNAP_TYPE <>", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeGreaterThan(Long value) {
            addCriterion("SNAP_TYPE >", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeGreaterThanOrEqualTo(Long value) {
            addCriterion("SNAP_TYPE >=", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeLessThan(Long value) {
            addCriterion("SNAP_TYPE <", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeLessThanOrEqualTo(Long value) {
            addCriterion("SNAP_TYPE <=", value, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeIn(List<Long> values) {
            addCriterion("SNAP_TYPE in", values, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeNotIn(List<Long> values) {
            addCriterion("SNAP_TYPE not in", values, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeBetween(Long value1, Long value2) {
            addCriterion("SNAP_TYPE between", value1, value2, "snapType");
            return (Criteria) this;
        }

        public Criteria andSnapTypeNotBetween(Long value1, Long value2) {
            addCriterion("SNAP_TYPE not between", value1, value2, "snapType");
            return (Criteria) this;
        }

        public Criteria andCarnumIsNull() {
            addCriterion("CARNUM is null");
            return (Criteria) this;
        }

        public Criteria andCarnumIsNotNull() {
            addCriterion("CARNUM is not null");
            return (Criteria) this;
        }

        public Criteria andCarnumEqualTo(String value) {
            addCriterion("CARNUM =", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumNotEqualTo(String value) {
            addCriterion("CARNUM <>", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumGreaterThan(String value) {
            addCriterion("CARNUM >", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumGreaterThanOrEqualTo(String value) {
            addCriterion("CARNUM >=", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumLessThan(String value) {
            addCriterion("CARNUM <", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumLessThanOrEqualTo(String value) {
            addCriterion("CARNUM <=", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumLike(String value) {
            addCriterion("CARNUM like", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumNotLike(String value) {
            addCriterion("CARNUM not like", value, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumIn(List<String> values) {
            addCriterion("CARNUM in", values, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumNotIn(List<String> values) {
            addCriterion("CARNUM not in", values, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumBetween(String value1, String value2) {
            addCriterion("CARNUM between", value1, value2, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarnumNotBetween(String value1, String value2) {
            addCriterion("CARNUM not between", value1, value2, "carnum");
            return (Criteria) this;
        }

        public Criteria andCarColorIsNull() {
            addCriterion("CAR_COLOR is null");
            return (Criteria) this;
        }

        public Criteria andCarColorIsNotNull() {
            addCriterion("CAR_COLOR is not null");
            return (Criteria) this;
        }

        public Criteria andCarColorEqualTo(String value) {
            addCriterion("CAR_COLOR =", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotEqualTo(String value) {
            addCriterion("CAR_COLOR <>", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorGreaterThan(String value) {
            addCriterion("CAR_COLOR >", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorGreaterThanOrEqualTo(String value) {
            addCriterion("CAR_COLOR >=", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLessThan(String value) {
            addCriterion("CAR_COLOR <", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLessThanOrEqualTo(String value) {
            addCriterion("CAR_COLOR <=", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorLike(String value) {
            addCriterion("CAR_COLOR like", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotLike(String value) {
            addCriterion("CAR_COLOR not like", value, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorIn(List<String> values) {
            addCriterion("CAR_COLOR in", values, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotIn(List<String> values) {
            addCriterion("CAR_COLOR not in", values, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorBetween(String value1, String value2) {
            addCriterion("CAR_COLOR between", value1, value2, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarColorNotBetween(String value1, String value2) {
            addCriterion("CAR_COLOR not between", value1, value2, "carColor");
            return (Criteria) this;
        }

        public Criteria andCarTypeIsNull() {
            addCriterion("CAR_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCarTypeIsNotNull() {
            addCriterion("CAR_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCarTypeEqualTo(String value) {
            addCriterion("CAR_TYPE =", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeNotEqualTo(String value) {
            addCriterion("CAR_TYPE <>", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeGreaterThan(String value) {
            addCriterion("CAR_TYPE >", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CAR_TYPE >=", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeLessThan(String value) {
            addCriterion("CAR_TYPE <", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeLessThanOrEqualTo(String value) {
            addCriterion("CAR_TYPE <=", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeLike(String value) {
            addCriterion("CAR_TYPE like", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeNotLike(String value) {
            addCriterion("CAR_TYPE not like", value, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeIn(List<String> values) {
            addCriterion("CAR_TYPE in", values, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeNotIn(List<String> values) {
            addCriterion("CAR_TYPE not in", values, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeBetween(String value1, String value2) {
            addCriterion("CAR_TYPE between", value1, value2, "carType");
            return (Criteria) this;
        }

        public Criteria andCarTypeNotBetween(String value1, String value2) {
            addCriterion("CAR_TYPE not between", value1, value2, "carType");
            return (Criteria) this;
        }

        public Criteria andChannelIsNull() {
            addCriterion("CHANNEL is null");
            return (Criteria) this;
        }

        public Criteria andChannelIsNotNull() {
            addCriterion("CHANNEL is not null");
            return (Criteria) this;
        }

        public Criteria andChannelEqualTo(String value) {
            addCriterion("CHANNEL =", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotEqualTo(String value) {
            addCriterion("CHANNEL <>", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThan(String value) {
            addCriterion("CHANNEL >", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL >=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThan(String value) {
            addCriterion("CHANNEL <", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL <=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLike(String value) {
            addCriterion("CHANNEL like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotLike(String value) {
            addCriterion("CHANNEL not like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelIn(List<String> values) {
            addCriterion("CHANNEL in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotIn(List<String> values) {
            addCriterion("CHANNEL not in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelBetween(String value1, String value2) {
            addCriterion("CHANNEL between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotBetween(String value1, String value2) {
            addCriterion("CHANNEL not between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andLocationIsNull() {
            addCriterion("LOCATION is null");
            return (Criteria) this;
        }

        public Criteria andLocationIsNotNull() {
            addCriterion("LOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andLocationEqualTo(String value) {
            addCriterion("LOCATION =", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotEqualTo(String value) {
            addCriterion("LOCATION <>", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThan(String value) {
            addCriterion("LOCATION >", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThanOrEqualTo(String value) {
            addCriterion("LOCATION >=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThan(String value) {
            addCriterion("LOCATION <", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThanOrEqualTo(String value) {
            addCriterion("LOCATION <=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLike(String value) {
            addCriterion("LOCATION like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotLike(String value) {
            addCriterion("LOCATION not like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationIn(List<String> values) {
            addCriterion("LOCATION in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotIn(List<String> values) {
            addCriterion("LOCATION not in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationBetween(String value1, String value2) {
            addCriterion("LOCATION between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotBetween(String value1, String value2) {
            addCriterion("LOCATION not between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagIsNull() {
            addCriterion("SUB_POLICE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagIsNotNull() {
            addCriterion("SUB_POLICE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagEqualTo(String value) {
            addCriterion("SUB_POLICE_FLAG =", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagNotEqualTo(String value) {
            addCriterion("SUB_POLICE_FLAG <>", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagGreaterThan(String value) {
            addCriterion("SUB_POLICE_FLAG >", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_POLICE_FLAG >=", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagLessThan(String value) {
            addCriterion("SUB_POLICE_FLAG <", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagLessThanOrEqualTo(String value) {
            addCriterion("SUB_POLICE_FLAG <=", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagLike(String value) {
            addCriterion("SUB_POLICE_FLAG like", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagNotLike(String value) {
            addCriterion("SUB_POLICE_FLAG not like", value, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagIn(List<String> values) {
            addCriterion("SUB_POLICE_FLAG in", values, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagNotIn(List<String> values) {
            addCriterion("SUB_POLICE_FLAG not in", values, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagBetween(String value1, String value2) {
            addCriterion("SUB_POLICE_FLAG between", value1, value2, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSubPoliceFlagNotBetween(String value1, String value2) {
            addCriterion("SUB_POLICE_FLAG not between", value1, value2, "subPoliceFlag");
            return (Criteria) this;
        }

        public Criteria andSnapDateIsNull() {
            addCriterion("SNAP_DATE is null");
            return (Criteria) this;
        }

        public Criteria andSnapDateIsNotNull() {
            addCriterion("SNAP_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andSnapDateEqualTo(Date value) {
            addCriterionForJDBCDate("SNAP_DATE =", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("SNAP_DATE <>", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateGreaterThan(Date value) {
            addCriterionForJDBCDate("SNAP_DATE >", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SNAP_DATE >=", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateLessThan(Date value) {
            addCriterionForJDBCDate("SNAP_DATE <", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SNAP_DATE <=", value, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateIn(List<Date> values) {
            addCriterionForJDBCDate("SNAP_DATE in", values, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("SNAP_DATE not in", values, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SNAP_DATE between", value1, value2, "snapDate");
            return (Criteria) this;
        }

        public Criteria andSnapDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SNAP_DATE not between", value1, value2, "snapDate");
            return (Criteria) this;
        }

        public Criteria andAreaIdIsNull() {
            addCriterion("AREA_ID is null");
            return (Criteria) this;
        }

        public Criteria andAreaIdIsNotNull() {
            addCriterion("AREA_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAreaIdEqualTo(String value) {
            addCriterion("AREA_ID =", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotEqualTo(String value) {
            addCriterion("AREA_ID <>", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdGreaterThan(String value) {
            addCriterion("AREA_ID >", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdGreaterThanOrEqualTo(String value) {
            addCriterion("AREA_ID >=", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdLessThan(String value) {
            addCriterion("AREA_ID <", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdLessThanOrEqualTo(String value) {
            addCriterion("AREA_ID <=", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdLike(String value) {
            addCriterion("AREA_ID like", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotLike(String value) {
            addCriterion("AREA_ID not like", value, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdIn(List<String> values) {
            addCriterion("AREA_ID in", values, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotIn(List<String> values) {
            addCriterion("AREA_ID not in", values, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdBetween(String value1, String value2) {
            addCriterion("AREA_ID between", value1, value2, "areaId");
            return (Criteria) this;
        }

        public Criteria andAreaIdNotBetween(String value1, String value2) {
            addCriterion("AREA_ID not between", value1, value2, "areaId");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}